List of properties

Entity Account
Key property ID


Property starting with A
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Abbreviation Abbreviation Abbreviation String Abbreviation
AccountCode Code Code String AccountCode
AccountEmployeeId Manager Manager Number AccountEmployeeId
AccountEmployeeName String AccountEmployeeName
AccountManagerID Manager Manager Number AccountManagerID
AccountManagerName Name Name String AccountManagerName
AccountManagerType Type Type String AccountManagerType
AccountName Name Name String AccountName
AccountStatus String AccountStatus
AddExtraReceiptToOrder Add extra receipt to sales order Add extra receipt to sales order Boolean AddExtraReceiptToOrder
AddressID String AddressID
AllowBackorder Back order Back order Boolean AllowBackorder
AllowPartialDelivery Allow Partial Delivery Allow Partial Delivery Boolean AllowPartialDelivery
ApplyShippingCharges Boolean ApplyShippingCharges
ASPDatabase Database Database String ASPDatabase
ASPDatabaseServer Server Server String ASPDatabaseServer
ASPWebsiteServer Website Website String ASPWebsiteServer
ASPWebsiteURL Website Website String ASPWebsiteURL
AttachUBL Attach UBL Attach UBL Boolean AttachUBL
Attention Notes Notes Boolean Attention
AutoAllocate Boolean AutoAllocate
AvalaraEntityUseCode Avalara entity use code Avalara entity use code String AvalaraEntityUseCode

Property starting with B
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
BankAccount Bank account Bank account String BankAccount
BankAccountType String BankAccountType
BICCode BIC code BIC code String BICCode
Blocked Blocked Blocked Boolean Blocked
BOELimitAmount BOE limit BOE limit Number BOELimitAmount
BOEMaxAmount BOE Maximum BOE Maximum Number BOEMaxAmount

Property starting with C
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Category_01 Category 1 Category 1 String Category_01 251 SIS The [Cicmpy.Category...
Category_02 Category 2 Category 2 String Category_02 251 SIS The [Cicmpy.Category...
Category_03 Category 3 Category 3 String Category_03 251 SIS The [Cicmpy.Category...
Category_04 Category 4 Category 4 String Category_04 251 SIS The [Cicmpy.Category...
Category_05 Category 5 Category 5 String Category_05 251 SIS The [Cicmpy.Category...
Category_06 Category 6 Category 6 String Category_06 251 SIS The [Cicmpy.Category...
Category_07 Category 7 Category 7 String Category_07 251 SIS The [Cicmpy.Category...
Category_08 Category 8 Category 8 String Category_08 251 SIS The [Cicmpy.Category...
Category_09 Category 9 Category 9 String Category_09 251 SIS The [Cicmpy.Category...
Category_10 Category 10 Category 10 String Category_10 251 SIS The [Cicmpy.Category...
Category_11 Category 11 Category 11 String Category_11 251 SIS The [Cicmpy.Category...
Category_12 Category 12 Category 12 String Category_12 251 SIS The [Cicmpy.Category...
Category_13 Category 13 Category 13 String Category_13 251 SIS The [Cicmpy.Category...
Category_14 Category 14 Category 14 String Category_14 251 SIS The [Cicmpy.Category...
Category_15 Category 15 Category 15 String Category_15 251 SIS The [Cicmpy.Category...
ChamberofCommerceNumber Chamber of Commerce Number Chamber of Commerce Number String ChamberofCommerceNumber
ChangeVatData Change Vat Data Change Vat Data Boolean ChangeVatData
ChangeVatServices Change Vat Services Data Change Vat Services Data Boolean ChangeVatServices
CheckDate Check date Check date Date CheckDate
CiscoDirectory String CiscoDirectory
CityOfLoadUnload City City String CityOfLoadUnload
ClassificationDescription Classification Classification String ClassificationDescription
ClassificationID Classification Classification String ClassificationID
CodeatSupplier Code at Supplier Code at Supplier String CodeatSupplier
CollectionInvoice Collection Collection String CollectionInvoice
CompanyCode Division Division String CompanyCode
CompanyCodeDebtorAccountID GUID CompanyCodeDebtorAccountID
CompanyName String CompanyName
CompanySize Size Size String CompanySize
CompanyType Company type Company type Number CompanyType
ContactAccountManager Manager Manager Number ContactAccountManager
ContactCompanyCode cnt_Administration cnt_Administration String ContactCompanyCode
ContactCreatedDate cnt_DateCreated cnt_DateCreated Date ContactCreatedDate
ContactCreator cnt_CreatedBy cnt_CreatedBy Number ContactCreator
ContactEmail E-mail E-mail String ContactEmail
ContactFaxNumber Fax Fax String ContactFaxNumber
ContactFirstName First First String ContactFirstName
ContactFullName Full name Full name String ContactFullName
ContactGender Gender Gender String ContactGender
ContactID Contact Contact GUID ContactID
ContactInitials Initials Initials String ContactInitials
ContactLanguage Language Language String ContactLanguage
ContactLanguageDescription Language description Language description String ContactLanguageDescription
ContactLastName Last Last String ContactLastName
ContactMiddleName Middle name Middle name String ContactMiddleName
ContactMobileNumber Mobile phone Mobile phone String ContactMobileNumber
ContactModifiedDate cnt_DateModified cnt_DateModified Date ContactModifiedDate
ContactModifier Modified by Modified by Number ContactModifier
ContactNumberFreeField1 Number Number Number ContactNumberFreeField1
ContactNumberFreeField2 Number Number Number ContactNumberFreeField2
ContactNumberFreeField3 Number Number Number ContactNumberFreeField3
ContactNumberFreeField4 Number Number Number ContactNumberFreeField4
ContactNumberFreeField5 Number Number Number ContactNumberFreeField5
ContactPhoneNumber Phone Phone String ContactPhoneNumber
ContactTitle Title Title String ContactTitle
CountryOfAssembly String CountryOfAssembly
CountryOfOrigin String CountryOfOrigin
CreatedDate Date CreatedDate
Creator Number Creator
CreatorName String CreatorName
CreditabilityScenario Credit scenario Credit scenario String CreditabilityScenario
CreditCardDescription Credit card desc Credit card desc String CreditCardDescription
CreditCardExpirationDate Date CreditCardExpirationDate
CreditCardHolder Credit card Credit card String CreditCardHolder
CreditcardNumberReference Credit card number Credit card number String CreditcardNumberReference
CreditLine Credit line Credit line Number CreditLine
CreditorCode Creditor code Creditor code String CreditorCode
CreditorNumber Creditor number Creditor number String CreditorNumber
CreditorNumberReference Number Number String CreditorNumberReference
CreditorType String CreditorType
CurrencyCode Currency Currency String CurrencyCode
CurrencyDescription String CurrencyDescription
CustomerID Customer Customer GUID CustomerID
CustomerSince Since Since Date CustomerSince
CustomerStatus Status Status String CustomerStatus
CustomerStatusDescription String CustomerStatusDescription
CustomerType Type Type String CustomerType
CustomerTypeDescription String CustomerTypeDescription

Property starting with D
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
DateFreeField1 Date Date Date DateFreeField1
DateFreeField2 Date Date Date DateFreeField2
DateFreeField3 Date Date Date DateFreeField3
DateFreeField4 Date Date Date DateFreeField4
DateFreeField5 Date Date Date DateFreeField5
DateLastReminder Date DateLastReminder
DebtorAccountName String DebtorAccountName
DebtorCode Debtor code Debtor code String DebtorCode
DebtorCreditorAccount Centralization Account Centralization Account String DebtorCreditorAccount
DebtorNumber Debtor number Debtor number String DebtorNumber
DebtorNumberReference Debtor number Debtor number String DebtorNumberReference
DefaultSelCode String DefaultSelCode
DefaultSelDescription String DefaultSelDescription
DeleteBankAccount Number DeleteBankAccount
DeliveryAddressline1 Address Address String DeliveryAddressline1
DeliveryAddressline2 Address Address String DeliveryAddressline2
DeliveryAddressline3 Address Address String DeliveryAddressline3
DeliveryCity City City String DeliveryCity
DeliveryCountry Country Country String DeliveryCountry
DeliveryCounty County County String DeliveryCounty
DeliveryMethod Delivery method Delivery method String DeliveryMethod
DeliverymethodDescription String DeliverymethodDescription
DeliveryPostCode Postcode Postcode String DeliveryPostCode
DeliveryState State State String DeliveryState
DeliveryTerms String DeliveryTerms
DestinationCountry String DestinationCountry
Directory String Directory
Discount Discount Discount Number Discount
Document Document Document GUID Document
DocumentCreatedDate Date DocumentCreatedDate
DocumentCreator String DocumentCreator
DocumentSubject Document Document String DocumentSubject
DunBradstreetNumber D & B Number D & B Number String DunBradstreetNumber

Property starting with E
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
EmailAddress E-mail E-mail String EmailAddress
ESFContactID GUID ESFContactID
ExemptNumber Tax Exempt No Tax Exempt No String ExemptNumber
Extension Extension Extension String Extension
ExtraDescriptionName String ExtraDescriptionName
ExtraDuty Boolean ExtraDuty
ExtraItemDescription Extra Item Description Extra Item Description String ExtraItemDescription

Property starting with F
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
FaxNumber Fax Fax String FaxNumber
FedCategory 1099 Category 1099 Category String FedCategory
FedIDNumber Fed. Id. No. Fed. Id. No. String FedIDNumber
FedIDType Fed. Id. Type Fed. Id. Type String FedIDType
FiscalCode String FiscalCode

Property starting with G
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
GLN GLN GLN String GLN 405 CMDM EDI
GroupDueDates String GroupDueDates
GuidFreeField1 GUID GuidFreeField1
GuidFreeField2 GUID GuidFreeField2
GuidFreeField3 GUID GuidFreeField3
GuidFreeField4 GUID GuidFreeField4
GuidFreeField5 GUID GuidFreeField5

Property starting with I
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
IBAN IBAN IBAN String IBAN
ID GUID ID
IncoTermAcknowledgeOrder Acknowledge order Acknowledge order Boolean IncoTermAcknowledgeOrder
IncoTermCode Incoterm Incoterm String IncoTermCode
IncoTermConfirmPrices Confirm prices Confirm prices Boolean IncoTermConfirmPrices
IncoTermProperty Incoterm code Incoterm code String IncoTermProperty
IntegerFreeField1 Number IntegerFreeField1
IntegerFreeField2 Number IntegerFreeField2
IntegerFreeField3 Number IntegerFreeField3
IntegerFreeField4 Number IntegerFreeField4
IntegerFreeField5 Number IntegerFreeField5
IntermediaryassociateID String IntermediaryassociateID
IntrastatSystem String IntrastatSystem
IntRegion String IntRegion
InvoiceAddress Address Address String InvoiceAddress
InvoiceAddress2 Address Address String InvoiceAddress2
InvoiceAddress3 Address Address String InvoiceAddress3
InvoiceAddressPostCode Postcode Postcode String InvoiceAddressPostCode
InvoiceCity City City String InvoiceCity
InvoiceCopies Number InvoiceCopies
InvoiceCountry Country Country String InvoiceCountry
InvoiceCounty County County String InvoiceCounty
InvoiceDebtor Invoice Invoice String InvoiceDebtor
InvoiceMethod Invoicing method Invoicing method String InvoiceMethod
InvoiceState State State String InvoiceState
IsBinaryServiceEnabled Boolean IsBinaryServiceEnabled
IsCommissionable Commissionable Commissionable Boolean IsCommissionable
IsTaxExempted Boolean IsTaxExempted

Property starting with J
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
JobDescription Job description Job description String JobDescription
JobTitle JobTitle JobTitle String JobTitle
JobTitleDescription String JobTitleDescription
JournalCode Journal Journal String JournalCode

Property starting with L
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
LogoFilename Logo Logo String LogoFilename

Property starting with M
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Mailbox Mailbox Mailbox String Mailbox
MailingAddress1 Address Address String MailingAddress1
MailingAddress2 Address Address String MailingAddress2
MailingAddress3 Address Address String MailingAddress3
MailingCity City City String MailingCity
MailingCountry Country Country String MailingCountry
MailingCountryDescription String MailingCountryDescription
MailingCounty County County String MailingCounty
MailingPostcode Postcode Postcode String MailingPostcode
MailingState State State String MailingState
MailingStateDescription String MailingStateDescription
ManagersCCDescription String ManagersCCDescription
ManagersCostCenter String ManagersCostCenter
MessageIDCompanyLogo GUID MessageIDCompanyLogo
MessageIDRemarks GUID MessageIDRemarks
ModifiedDate Date ModifiedDate
Modifier Number Modifier
ModifierName String ModifierName

Property starting with N
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Note String Note
NumberFreeField1 Number Number Number NumberFreeField1
NumberFreeField2 Number Number Number NumberFreeField2
NumberFreeField3 Number Number Number NumberFreeField3
NumberFreeField4 Number Number Number NumberFreeField4
NumberFreeField5 Number Number Number NumberFreeField5

Property starting with O
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
OffsetAccountName String OffsetAccountName
OffsetLedgerAccount OffSet GL OffSet GL String OffsetLedgerAccount
OrderConfirmation Confirm SO Confirm SO String OrderConfirmation

Property starting with P
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Parent Parent Parent GUID Parent
ParentCode String ParentCode
ParentName String ParentName
PayeeName Payee Name Payee Name String PayeeName
PaymentCondition Payment condition Payment condition String PaymentCondition
PaymentConditionDescription String PaymentConditionDescription
PaymentDay1 Payment day 1 Payment day 1 Number PaymentDay1
PaymentDay2 Payment day 2 Payment day 2 Number PaymentDay2
PaymentDay3 Payment day 3 Payment day 3 Number PaymentDay3
PaymentDay4 Payment day 4 Payment day 4 Number PaymentDay4
PaymentDay5 Payment day 5 Payment day 5 Number PaymentDay5
PhoneExtension Extension Extension String PhoneExtension
PhoneNumber Phone Phone String PhoneNumber
PhoneQueue Phone queue Phone queue String PhoneQueue
PictureFilename File name File name String PictureFilename
PostalAddressLine1 Address Address String PostalAddressLine1
PostalAddressLine2 Address Address String PostalAddressLine2
PostalAddressLine3 Address Address String PostalAddressLine3
PostalCity City City String PostalCity
PostalCountry Country Country String PostalCountry
PostalCounty County County String PostalCounty
PostalPostCode PostCode PostCode String PostalPostCode
PostalState State State String PostalState
PriceList Price list Price list String PriceList
PriceListDescription String PriceListDescription
PurchaseOrderConfirmation Boolean PurchaseOrderConfirmation

Property starting with R
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Rating Rating Rating String Rating
RatingDescription String RatingDescription
Reminder Reminder Reminder Boolean Reminder
ResellerCode String ResellerCode
ResellerID Reseller Reseller GUID ResellerID
ResellerName String ResellerName

Property starting with S
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
SectorCode Sector Sector String SectorCode
SectorDescription String SectorDescription
SecurityLevel Security level Security level Number SecurityLevel
SignDate Date SignDate
SizeDescription String SizeDescription
Source Source Source String Source
SourceDescription String SourceDescription
StatementDate Date StatementDate
StatementFrequency Statement Freq. Statement Freq. String StatementFrequency
StatementNumber Number StatementNumber
StatementPrint Print debtor statements Print debtor statements Boolean StatementPrint
StatFactor String StatFactor
SubSector Subsector Subsector String SubSector
SubSectorDescription String SubSectorDescription
SupplierID Supplier Supplier GUID SupplierID
SyncID GUID SyncID

Property starting with T
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Terms String Terms
TerritoryCode Territory code Territory code String TerritoryCode
TextFreeField1 Text Text String TextFreeField1
TextFreeField10 Text Text String TextFreeField10
TextFreeField11 Text Text String TextFreeField11
TextFreeField12 Text Text String TextFreeField12
TextFreeField13 Text Text String TextFreeField13
TextFreeField14 Text Text String TextFreeField14
TextFreeField15 Text Text String TextFreeField15
TextFreeField16 Text Text String TextFreeField16
TextFreeField17 Text Text String TextFreeField17
TextFreeField18 Text Text String TextFreeField18
TextFreeField19 Text Text String TextFreeField19
TextFreeField2 Text Text String TextFreeField2
TextFreeField20 Text Text String TextFreeField20
TextFreeField21 Text Text String TextFreeField21
TextFreeField22 Text Text String TextFreeField22
TextFreeField23 Text Text String TextFreeField23
TextFreeField24 Text Text String TextFreeField24
TextFreeField25 Text Text String TextFreeField25
TextFreeField26 Text Text String TextFreeField26
TextFreeField27 Text Text String TextFreeField27
TextFreeField28 Text Text String TextFreeField28
TextFreeField29 Text Text String TextFreeField29
TextFreeField3 Text Text String TextFreeField3
TextFreeField30 Text Text String TextFreeField30
TextFreeField4 Text Text String TextFreeField4
TextFreeField5 Text Text String TextFreeField5
TextFreeField6 Text Text String TextFreeField6
TextFreeField7 Text Text String TextFreeField7
TextFreeField8 Text Text String TextFreeField8
TextFreeField9 Text Text String TextFreeField9
TitleDescription Title description Title description String TitleDescription
TransactionA String TransactionA
TransactionB String TransactionB
Transport String Transport
Transshipment String Transshipment
TriangularCountry String TriangularCountry
TypeSince Type Type Date TypeSince

Property starting with U
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
UseAvalaraTaxation Boolean UseAvalaraTaxation

Property starting with V
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
VatCode Vat code Vat code String VatCode
VATLiability Vat liability Vat liability String VATLiability
VATNumber VAT Number VAT Number String VATNumber
VatServices Vat services Vat services String VatServices

Property starting with W
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
WebAddress Portal Portal String WebAddress

Property starting with Y
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
YesNoFreeField1 Yes/No Yes/No Boolean YesNoFreeField1
YesNoFreeField2 Yes/No Yes/No Boolean YesNoFreeField2
YesNoFreeField3 Yes/No Yes/No Boolean YesNoFreeField3
YesNoFreeField4 Yes/No Yes/No Boolean YesNoFreeField4
YesNoFreeField5 Yes/No Yes/No Boolean YesNoFreeField5

Detail information of properties

Property starting with A
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Abbreviation cnt_titleabbreviation String 8 0
AccountCode CustomerCode String 20 0
AccountEmployeeId AccountEmployeeId Number 10 0 0
AccountEmployeeName AccountEmployeeName String 70 0
AccountManagerID AccountManager Number 10 0
AccountManagerName AccountManagerName String 64 0
AccountManagerType AccountManagerType String 1 0
A,35,Applicant
C,24081,Contractor
E,9551,Employee
K,240,Customer
R,995,Partner
S,29493,Student
T,29542,Temporary
V,8148,Vacancy
AccountName Name String 50 0
AccountStatus Status String 1 0 S
B,1267,Blocked
C,30798,Corporate
E,8573,Exit
H,31092,High attention
P,24822,Prospect
R,5961,Reference
S,24011,Standard
AddExtraReceiptToOrder AddExtraReceiptToOrder Boolean 1 0 0 0 1
AddressID AddressID String 8191 0
AllowBackorder AllowBackOrders Boolean 0 0 0
AllowPartialDelivery AllowPartialShipment Boolean 0 0 1
ApplyShippingCharges ApplyShippingCharges Boolean 1 0 0 0 1
ASPDatabase ASPDatabase String 30 0
ASPDatabaseServer ASPServer String 30 0
ASPWebsiteServer ASPWebServer String 30 0
ASPWebsiteURL ASPWebSite String 128 0
AttachUBL AttachUBL Boolean 0 0 0
Attention Attention Boolean 1 0 0 0 1
AutoAllocate AutoAllocate Boolean 1 0 0 0 1
AvalaraEntityUseCode AvalaraEntityUseCode String 1 0

Property starting with B
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
BankAccount BankAccount String 34 0
BankAccountType BankAccountType String 3 0
AT,0,Austrian bank accounts
BE,0,Belgian bankaccounts
CZ,0,Czech account number
DE,0,German bankaccounts
DEF,0,Default bank account type
ES,0,Spanish bankaccounts
FR,0,French bankaccounts
GB,0,British bankaccounts
GNL,0,Blocked Dutch bank account
GPB,0,Blocked Postbank account
HU,0,Hungarian bank accounts
IBA,0,IBAN International Bank Account Number
IT,0,Italian bank accounts
LU,0,Luxemburg bankaccounts
NL,0,Dutch bankaccounts
PB,0,Postbankaccounts
RU,0,Russian bank accounts
BICCode BICCode String 11 0
Blocked Blocked Boolean 1 0 0 0 1
BOELimitAmount BOELimitAmount Number 16 4
BOEMaxAmount BOEMaxAmount Number 16 4

Property starting with C
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Category_01 Category_01 String 30 0
Category_02 Category_02 String 30 0
Category_03 Category_03 String 30 0
Category_04 Category_04 String 30 0
Category_05 Category_05 String 30 0
Category_06 Category_06 String 30 0
Category_07 Category_07 String 30 0
Category_08 Category_08 String 30 0
Category_09 Category_09 String 30 0
Category_10 Category_10 String 30 0
Category_11 Category_11 String 30 0
Category_12 Category_12 String 30 0
Category_13 Category_13 String 30 0
Category_14 Category_14 String 30 0
Category_15 Category_15 String 30 0
ChamberofCommerceNumber ChamberOfCommerce String 20 0
ChangeVatData ChangeVatCode Boolean 1 0 1 0 1
ChangeVatServices ChangeVatServices Boolean 1 0 1 0 1
CheckDate CheckDate Date 8 0
CiscoDirectory cntp_directory String 30 0
CityOfLoadUnload CityOfLoadUnload String 10 0
ClassificationDescription ClassificationDescription String 50 0
ClassificationID ClassificationID String 3 0
CodeatSupplier CustomerCodeEx String 10 0
CollectionInvoice Collect String 1 0 N
F,10107,On Invoice Debtor
N,1015,No
O,10112,On Order Debtor
CompanyCode Administration String 3 0
CompanyCodeDebtorAccountID DivisionDebtorAccountID GUID 16 0
CompanyName AdministrationDescription String 60 0
CompanySize CompanySize String 10 0
CompanyType CompanyType Number 4 0 3
ContactAccountManager cnt_AccountManager Number 10 0 AccountManager
ContactCompanyCode cnt_Administration String 3 0 Administration
ContactCreatedDate cnt_DateCreated Date 0 0 NOW
ContactCreator cnt_CreatedBy Number 10 0 HUMRESID
ContactEmail cnt_Email String 128 0 EMail
ContactFaxNumber cnt_Fax String 25 0
ContactFirstName cnt_FirstName String 30 0
ContactFullName ContactFullName String 100 0
ContactGender Gender String 1 0 O
M,5155,Male
O,1067,Unknown
V,5156,Female
ContactID ContactID GUID 16 0
ContactInitials cnt_Initials String 10 0
ContactLanguage cnt_Language String 3 0
ContactLanguageDescription cnt_LanguageDescription String 30 0
ContactLastName cnt_LastName String 50 0 --
ContactMiddleName cnt_MiddleName String 30 0
ContactMobileNumber cnt_Mobile String 25 0
ContactModifiedDate cnt_DateModified Date 0 0 NOW
ContactModifier cnt_ModifiedBy Number 10 0 HUMRESID
ContactNumberFreeField1 ContactNumberField1 Number 16 2
ContactNumberFreeField2 ContactNumberField2 Number 16 2
ContactNumberFreeField3 ContactNumberField3 Number 16 2
ContactNumberFreeField4 ContactNumberField4 Number 16 2
ContactNumberFreeField5 ContactNumberField5 Number 16 2
ContactPhoneNumber cnt_Phone String 25 0
ContactTitle cnt_Title String 4 0
CountryOfAssembly CountryOfAssembly String 3 0
CountryOfOrigin CountryOfOrigin String 3 0
CreatedDate DateCreated Date 0 0 NOW
Creator CreatedBy Number 10 0 HUMRESID
CreatorName CreatedByName String 64 0
CreditabilityScenario CreditabilityScenario String 1 0 N
A,31845,Payment agreement
C,30768,Complaints
N,6486,Normal
T,31846,Transferred
CreditCardDescription CreditCardDescription String 15 0
CreditCardExpirationDate ExpiryDate Date 8 0
CreditCardHolder CreditCardHolder String 40 0
CreditcardNumberReference Creditcard String 34 0
CreditLine CreditLine Number 12 2 0
CreditorCode crdcode String 20 0
CreditorNumber crdnr String 6 0
CreditorNumberReference CreditorNumber String 6 0
CreditorType CreditorType String 1 0
B,12208,Tax authority,Industry Assurance Board
C,8504,Creditor
E,17121,Employee
O,7738,Subcontractor
CurrencyCode Currency String 3 0
CurrencyDescription CurrencyDescription String 60 0
CustomerID DivisionDebtorID GUID 16 0
CustomerSince CustomerSince Date 0 0 NOW
CustomerStatus CustomerStatus String 1 0 N
A,2212,Active
B,1267,Blocked
E,29544,Exit
N,29,Not Validated
P,41,Pilot
R,20344,Reference
S,38,Passive
CustomerStatusDescription CustomerStatusDescription String 30 0
CustomerType CustomerType String 1 0 N
A,24820,Associate
B,8371,Bank
C,14006,Customer
D,64,Division
E,9551,Employee
L,25454,Lead
N,29,Not Validated
P,24822,Prospect
R,24870,Reseller
S,5098,Supplier
T,15235,Suspect
CustomerTypeDescription CustomerTypeDescription String 30 0

Property starting with D
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
DateFreeField1 DateField1 Date 8 0
DateFreeField2 DateField2 Date 8 0
DateFreeField3 DateField3 Date 8 0
DateFreeField4 DateField4 Date 8 0
DateFreeField5 DateField5 Date 8 0
DateLastReminder DateLastReminder Date 8 0
DebtorAccountName CentralizationAccountName String 60 0
DebtorCode debcode String 20 0
DebtorCreditorAccount CentralizationAccount String 9 0
DebtorNumber debnr String 6 0
DebtorNumberReference DebtorNumber String 6 0
DefaultSelCode DefaultSelCode String 2 0
DefaultSelDescription DefaultSelDescription String 30 0
DeleteBankAccount DeleteBankAccount Number 1 0 0
DeliveryAddressline1 DelAddress String 100 0
DeliveryAddressline2 DelAddress2 String 100 0
DeliveryAddressline3 DelAddress3 String 100 0
DeliveryCity DelCity String 100 0
DeliveryCountry DelCountry String 3 0
DeliveryCounty DelCounty String 100 0
DeliveryMethod DeliveryMethod String 5 0
DeliverymethodDescription DeliveryMethodDescription String 40 0
DeliveryPostCode DelPostCode String 20 0
DeliveryState DelState String 3 0
DeliveryTerms DeliveryTerms String 10 0
DestinationCountry DestinationCountry String 3 0
Directory Directory String 30 0
Discount Discount Number 6 2 0
Document Document GUID 16 0
DocumentCreatedDate DocumentCreatedDate Date 8 0
DocumentCreator DocumentCreatedByFullName String 40 0
DocumentSubject DocumentSubject String 255 0
DunBradstreetNumber DunsNumber String 9 0

Property starting with E
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
EmailAddress Email String 128 0
ESFContactID ESFContactID GUID 16 0
ExemptNumber ExemptNumber String 20 0
Extension cnt_PhoneExtension String 10 0
ExtraDescriptionName ItemCodeName String 20 0
ExtraDuty ExtraDuty Boolean 1 0 0 0 1
ExtraItemDescription ItemCode String 2 0

Property starting with F
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
FaxNumber Fax String 25 0
FedCategory FedCategory String 4 0
FedIDNumber FedIDNumber String 13 0
FedIDType FedIDType String 1 0
B,8872,None
F,40036,Federal ID no.
S,7655,Social security no.
FiscalCode FiscalCode String 30 0

Property starting with G
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
GLN GLN String 20 0
GroupDueDates GroupPayments String 1 0 N
A,17828,Always collect
I,5160,Use default settings
N,17951,Never collect
GuidFreeField1 GUIDField1 GUID 16 0
GuidFreeField2 GUIDField2 GUID 16 0
GuidFreeField3 GUIDField3 GUID 16 0
GuidFreeField4 GUIDField4 GUID 16 0
GuidFreeField5 GUIDField5 GUID 16 0

Property starting with I
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
IBAN IBAN String 34 0
ID ID GUID 16 0
IncoTermAcknowledgeOrder IncoTermAcknowledgeOrder Boolean 0 0 0
IncoTermCode IncoTermCode String 3 0
IncoTermConfirmPrices IncoTermConfirmPrices Boolean 0 0 0
IncoTermProperty IncoTermProperty String 60 0
IntegerFreeField1 NumIntField1 Number 4 0 0
IntegerFreeField2 NumIntField2 Number 4 0 0
IntegerFreeField3 NumIntField3 Number 4 0 0
IntegerFreeField4 NumIntField4 Number 4 0 0
IntegerFreeField5 NumIntField5 Number 4 0 0
IntermediaryassociateID IntermediaryassociateID String 10 0
IntrastatSystem IntrastatSystem String 10 0
IntRegion IntRegion String 10 0
InvoiceAddress InvAddress String 100 0
InvoiceAddress2 InvAddress2 String 100 0
InvoiceAddress3 InvAddress3 String 100 0
InvoiceAddressPostCode InvPostCode String 20 0
InvoiceCity InvCity String 100 0
InvoiceCopies InvoiceCopies Number 4 0
InvoiceCountry InvCountry String 3 0
InvoiceCounty InvCounty String 100 0
InvoiceDebtor InvoiceDebtor String 6 0
InvoiceMethod InvoiceMethod String 1 0
E,36057,Electronically
M,5804,E-mail
P,8650,Printer
T,0,TNT
InvoiceState InvState String 3 0
IsBinaryServiceEnabled IsBinaryServiceEnabled Boolean 1 0 0 0 1
IsCommissionable IsCommissionable Boolean 1 0 0 0 1
IsTaxExempted IsTaxExempted Boolean 0 0 0

Property starting with J
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
JobDescription cnt_JobDescription String 50 0 --
JobTitle cnt_JobTitle String 12 0
JobTitleDescription cnt_JobTitleDescription String 50 0
JournalCode JournalCode String 3 0

Property starting with L
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
LogoFilename LogoFilename String 128 0

Property starting with M
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Mailbox Mailbox String 128 0
MailingAddress1 MailAddress String 100 0
MailingAddress2 MailAddress2 String 100 0
MailingAddress3 MailAddress3 String 100 0
MailingCity MailCity String 100 0
MailingCountry MailCountry String 3 0
MailingCountryDescription MailCountryDescription String 30 0
MailingCounty MailCounty String 100 0
MailingPostcode MailPostcode String 20 0
MailingState MailState String 3 0
MailingStateDescription StateDescription String 100 0
ManagersCCDescription ManagerCostCenterDesc String 50 0
ManagersCostCenter ManagerCostCenter String 8 0
MessageIDCompanyLogo MessageID_logo GUID 16 0
MessageIDRemarks MessageID_note GUID 16 0
ModifiedDate DateModified Date 0 0 NOW
Modifier ModifiedBy Number 10 0 HUMRESID
ModifierName ModifiedByName String 64 0

Property starting with N
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Note Notes String 8191 0
NumberFreeField1 NumberField1 Number 16 2
NumberFreeField2 NumberField2 Number 16 2
NumberFreeField3 NumberField3 Number 16 2
NumberFreeField4 NumberField4 Number 16 2
NumberFreeField5 NumberField5 Number 16 2

Property starting with O
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
OffsetAccountName OffSetAccountName String 60 0
OffsetLedgerAccount OffSetAccount String 9 0
OrderConfirmation PurchaseReceipt String 1 0 N
A,1014,Yes
B,3726,Back order
N,1015,No

Property starting with P
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Parent Parent GUID 16 0
ParentCode ParentCode String 20 0
ParentName ParentName String 64 0
PayeeName PayeeName String 40 0
PaymentCondition PaymentCondition String 2 0
PaymentConditionDescription PaymentConditionDescription String 30 0
PaymentDay1 PaymentDay1 Number 2 0
PaymentDay2 PaymentDay2 Number 2 0
PaymentDay3 PaymentDay3 Number 2 0
PaymentDay4 PaymentDay4 Number 2 0
PaymentDay5 PaymentDay5 Number 2 0
PhoneExtension PhoneExtension String 10 0
PhoneNumber Phone String 25 0
PhoneQueue PhoneQueue String 15 0
PictureFilename cnt_picturefilename String 128 0
PostalAddressLine1 PosAddress String 100 0
PostalAddressLine2 PosAddress2 String 100 0
PostalAddressLine3 PosAddress3 String 100 0
PostalCity PosCity String 100 0
PostalCountry PosCountry String 3 0
PostalCounty PosCounty String 100 0
PostalPostCode PosPostCode String 20 0
PostalState PosState String 3 0
PriceList PriceList String 15 0
PriceListDescription PriceListDescription String 30 0
PurchaseOrderConfirmation PurchaseOrderConfirmation Boolean 1 0 0 0 1

Property starting with R
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Rating Rating String 1 0
RatingDescription RatingDescription String 100 0
Reminder Reminder Boolean 1 0 1 0 1
ResellerCode ResellerCode String 20 0
ResellerID ResellerID GUID 16 0
ResellerName ResellerName String 64 0

Property starting with S
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
SectorCode IndustrySector String 10 0
SectorDescription IndustrySectorDescription String 100 0
SecurityLevel SecurityLevel Number 3 0 10
SignDate SignDate Date 0 0
SizeDescription CompanySizeDescription String 40 0
Source CustomerOrigin String 3 0 P
SourceDescription CustomerOriginDescription String 40 0
StatementDate StatementDate Date 8 0
StatementFrequency StatementFrequency String 1 0
D,0,Discretionary
M,0,Monthly
N,0,No statement
Q,0,Quarterly
S,0,Semi-Monthly
W,0,Weekly
StatementNumber StatementNumber Number 5 0
StatementPrint StatementPrint Boolean 0 0 1
StatFactor StatFactor String 3 0
SubSector SubSector String 10 0
SubSectorDescription SubSectorDescription String 40 0
SupplierID DivisionCreditorID GUID 16 0
SyncID SyncID GUID 16 0

Property starting with T
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Terms Terms String 5 0 0
TerritoryCode TerritoryCode String 5 0
TextFreeField1 TextField1 String 80 0
TextFreeField10 TextField10 String 75 0
TextFreeField11 TextField11 String 80 0
TextFreeField12 TextField12 String 80 0
TextFreeField13 TextField13 String 80 0
TextFreeField14 TextField14 String 80 0
TextFreeField15 TextField15 String 80 0
TextFreeField16 TextField16 String 80 0
TextFreeField17 TextField17 String 80 0
TextFreeField18 TextField18 String 80 0
TextFreeField19 TextField19 String 80 0
TextFreeField2 TextField2 String 80 0
TextFreeField20 TextField20 String 80 0
TextFreeField21 TextField21 String 80 0
TextFreeField22 TextField22 String 80 0
TextFreeField23 TextField23 String 75 0
TextFreeField24 TextField24 String 80 0
TextFreeField25 TextField25 String 80 0
TextFreeField26 TextField26 String 80 0
TextFreeField27 TextField27 String 80 0
TextFreeField28 TextField28 String 80 0
TextFreeField29 TextField29 String 80 0
TextFreeField3 TextField3 String 80 0
TextFreeField30 TextField30 String 80 0
TextFreeField4 TextField4 String 80 0
TextFreeField5 TextField5 String 80 0
TextFreeField6 TextField6 String 75 0
TextFreeField7 TextField7 String 75 0
TextFreeField8 TextField8 String 75 0
TextFreeField9 TextField9 String 75 0
TitleDescription cnt_TitleDescription String 30 0
TransactionA TransactionA String 10 0
TransactionB TransactionB String 10 0
Transport Transport String 10 0
Transshipment Transshipment String 10 0
TriangularCountry TriangularCountry String 3 0
TypeSince TypeSince Date 0 0 NOW

Property starting with U
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
UseAvalaraTaxation UseAvalaraTaxation Boolean 0 0 0

Property starting with V
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
VatCode VatCode String 15 0
VATLiability VATLiability String 1 0 L
E,31873,Exempted
L,1964,Liable to pay VAT
N,31872,Not liable to pay VAT
VATNumber VatNumber String 20 0
VatServices VatServices String 15 0

Property starting with W
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
WebAddress WebAddress String 128 0

Property starting with Y
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
YesNoFreeField1 YesNoField1 Boolean 0 0 0
YesNoFreeField2 YesNoField2 Boolean 0 0 0
YesNoFreeField3 YesNoField3 Boolean 0 0 0
YesNoFreeField4 YesNoField4 Boolean 0 0 0
YesNoFreeField5 YesNoField5 Boolean 0 0 0

List of obsolete properties
There is no obsolete property